/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package com.sarco.bwi.lib.mysql;

/**
 *
 * @author iktsup
 */
public class Misc {
    public static final class COLUMNS {
        public static final class T_NODE {
            private static final String IDNODE = "idnode";
            private static final String CURR_FRAME = "curr_frame";
            private static final String END_FRAME = "end_frame";
            private static final String PERCENT_DONE = "percent_done";
            private static final String START_FRAME = "start_frame";
            private static final String SYSTEM = "system";
            private static final String TIME_LEFT = "time_left";
        }
        public static final class T_LOG {
            private static final String IDLOG = "idlog";
            private static final String IDNODE = "idnode";
            private static final String DATE = "date";
            private static final String CURR_FRAME = "curr_frame";
            private static final String END_FRAME = "end_frame";
            private static final String PERCENT_DONE = "percent_done";
            private static final String START_FRAME = "start_frame";
        }
        public static final class T_JOBS {
            private static final String IDJOBS     = "idjobs";
            private static final String IDNODE     = "idnode";
            private static final String SFRAME     = "sframe";
            private static final String EFRAME     = "eframe";
            private static final String IS_TAKEN   = "is_taken";
        }
    }
    public static final class Tables {
        private static final String NODE    = "node";
        private static final String LOG     = "log";
        private static final String JOBS    = "jobs";
    }
    private static final String SQL_GET_NODE_DATA = "SELECT * FROM "
            + Tables.NODE;
    private static final String SQL_GET_LOG_DATA = "SELECT * FROM "
            + Tables.LOG;
    private static final String SQL_GET_JOBS_DATA = "SELECT * FROM "
            + Tables.JOBS;

    public static final String DEFAULT_DB   = "bwi";
    public static final String DEFAULT_USER = "root";
    public static final String DEFAULT_PASS = "";
    public static final String DEFAULT_HOST = "127.0.0.1";
    private static final String SQL_SPLIT_ROW = "##";
    private static final String SQL_SPLIT_COL = "::";
}
